create external table jms_ods.tab_door_pick_up (
    id string comment '批次号',
    batch_id string comment '主键id',
    input_time timestamp comment '统计日期',
    organ_code string comment '组织编码',
    organ_name string comment '组织名称',
    province string comment '省',
    city string comment '市',
    branch_code string comment '分公司编码',
    order_num string comment '总单量',
    recept_num string comment '接单量',
    pick_num string comment '取件量',
    cancel_num string comment '取消量',
    overtime_pick_num string comment '超时取件量',
    timely_pick_num string comment '取件及时量',
    break_num string comment '爽约量',
    courier_change_num string comment '快递员改约量',
    change_other_num string comment '改约到其他日期量',
    timely_pick_per string comment '取件及时率',
    cancel_per string comment '取消率',
    break_per string comment '爽约率',
    courier_change_per string comment '快递员改约率',
    complaint_num string comment '投诉量',
    complaint_again_num string comment '二次投诉量',
    complaint_per string comment '投诉率',
    send_back_num string comment '自行寄回单量',
    delete_flag string comment '删除标识',
    create_time timestamp comment '创建时间',
    update_time timestamp comment '更新时间'
)
comment '上门取件内容表-爬虫数据'
partitioned by (dt string comment '抽取日期')
stored as parquet
location '/dw/hive/jms_ods.db/external/tab_door_pick_up';
